﻿using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Text;
using OpenAuth.Repository.Domain;
using OpenAuth.Repository.Interface;

namespace OpenAuth.App
{
    public class CGGYW006App : ApiBaseApp<CGGYW006>
    {
        public CGGYW006App(IApiRepository<CGGYW006> repository) : base(repository)
        {
        }
        /// <summary>
        /// 查询HIS账单信息（账单查询）
        /// </summary>
        /// <param name="cxrq">查询日期</param>
        /// <returns></returns>
        public IEnumerable<CGGYW006> QueryCGGYW006ByCxrq(string cxrq, string zflb)
        {
            List<SqlParameter> param = new List<SqlParameter>();
            param.Add(new SqlParameter("@Cxrq", cxrq));
            param.Add(new SqlParameter("@Zflb", zflb));
            param.Add(new SqlParameter("@Czyh", "hf001"));
            var result = Query<CGGYW006>("exec usp_web_webtrans_CGGYW006 @cxrq=@Cxrq,@zflb=@Zflb,@czyh=@Czyh", param);
            return result;
        }
    }
}
